610. Triangle Judgement


Posted by ikl258794613 on 2024-02-26

Table: Triangle

Column Name Type
x int
y int
z int

In SQL, (x, y, z) is the primary key column for this table.
Each row of this table contains the lengths of three line segments.

Report for every three line segments whether they can form a triangle.

Return the result table in any order.

The result format is in the following example.

Example 1:

Input:
Triangle table:

x y z
13 15 30
10 20 15

Output:

x y z triangle
13 15 30 No
10 20 15 Yes

SELECT x ,y ,z ,IF( x+y>z AND x+z>y AND y+z>x , 'Yes','No') AS triangle
FROM Triangle

#SQL







Related Posts

Vue.js 學習旅程Mile 11 – Computed 計算屬性篇

Vue.js 學習旅程Mile 11 – Computed 計算屬性篇

Reactive Programming 簡介與教學(以 RxJS 為例)

Reactive Programming 簡介與教學(以 RxJS 為例)

[JS Behind The Scene] 從 for loop 理解 scope 和 event loop 的運作機制

[JS Behind The Scene] 從 for loop 理解 scope 和 event loop 的運作機制


Comments